<Page id="1" templateExtension="html" relativePath="." fullRelativePath="." secured="False" urlType="Relative" isIncluded="False" SSLAccess="False" needGeneration="0" wizardTheme="Aqua" wizardThemeType="File">
	<Components>
		<Grid id="2" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="10" connection="projectkar" dataSource=" SELECT ALL ITEM.NAME item_name, ITEM.DESCRIPTION, ITEM.ID item_id, ITEM.&quot;MONEY&quot; money, &quot;USER&quot;.NAME owner,nvl(num_buyed.num,0) num
  FROM ITEM, &quot;USER&quot;,
       (select ite_id,count(buyed.id) num 
         from buyed
         group by ite_id
         order by num) num_buyed 
 WHERE 
  (ITEM.USE_ID = &quot;USER&quot;.ID)  and 
  (item.ite_id={CATEGORY_ID}) and
  (num_buyed.ite_id(+)=item.id)" JoinIsNull="True" name="ITEM_USER" pageSizeLimit="100" wizardCaption="List of ITEM, &quot; USER&quot; " wizardTheme="Aqua" wizardThemeType="File" wizardGridType="Columnar" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="True" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters" activeTableType="dataSource">
			<Components>
				<Label id="55" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="owner" wizardTheme="Aqua" wizardThemeType="File" fieldSource="OWNER">
					<Components/>
					<Events/>
				</Label>
				<Label id="40" fieldSourceType="DBColumn" dataType="Float" html="False" editable="False" name="num_buyed" fieldSource="NUM" wizardCaption="Num Buyed" wizardTheme="Aqua" wizardThemeType="File" wizardSize="12" wizardMaxLength="12" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="41" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="ITEM_NAME" fieldSource="ITEM_NAME" wizardCaption="ITEM NAME" wizardTheme="Aqua" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="42" fieldSourceType="DBExpression" dataType="Float" html="False" editable="False" name="MONEY" fieldSource="MONEY" wizardCaption="MONEY" wizardTheme="Aqua" wizardThemeType="File" wizardSize="12" wizardMaxLength="12" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Navigator id="43" name="Navigator" wizardPagingType="ImageButtons" wizardFirst="False" wizardFirstText="First" wizardPrev="True" wizardPrevText="Prev" wizardNext="True" wizardNextText="Next" wizardLast="False" wizardLastText="Last" wizardImages="True" wizardSize="10" wizardTotalPages="False" wizardHideDisabled="False" wizardOfText="of" wizardTheme="Aqua" wizardThemeType="File" wizardImagesScheme="Aqua" type="Simple">
					<Components/>
					<Events/>
				</Navigator>
			</Components>
			<Events/>
			<TableParameters>
				<TableParameter id="45" conditionType="Parameter" useIsNull="True" field="ITE_ID" dataType="Integer" searchConditionType="NotEqual" parameterType="URL" logicOperator="And" parameterSource="category" orderNumber="1"/>
			</TableParameters>
			<JoinTables>
				<JoinTable id="51" tableName="ITEM" posWidth="177" posHeight="243" posLeft="10" posTop="10"/>
			</JoinTables>
			<JoinLinks/>
			<Fields>
				<Field id="52" tableName="ITEM" alias="ITEM_NAME" fieldName="NAME"/>
				<Field id="53" tableName="ITEM" fieldName="MONEY"/>
			</Fields>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="54" variable="CATEGORY_ID" parameterType="URL" defaultValue="0" dataType="Integer" parameterSource="CATEGORY_ID" format="0;(0)"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
	</Components>
	<CodeFiles>
		<CodeFile id="Model" language="JSP" name="see_category_softwares.xml" path="." comment="&lt;!--" commentEnd="--&gt;" codePage="iso-8859-1" forShow="False"/>
		<CodeFile id="JSP" language="JSP" name="see_category_softwares.jsp" path="." comment="&lt;%--" commentEnd="--%&gt;" codePage="iso-8859-1" forShow="True" url="see_category_softwares.jsp"/>
		<CodeFile id="Handlers" language="JSP" name="see_category_softwaresHandlers.jsp" path="." comment="//" codePage="iso-8859-1" forShow="False"/>
	</CodeFiles>
	<SecurityGroups/>
	<Events/>
</Page>
